package com.tencent.mapper;

import com.tencent.entity.Plan;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author: Fame
 * @date: 2022-08-31 11:23
 * @description:
 */

public interface PlanMapper {


    @Results(id = "plan",value = {
            @Result(property = "id",column = "p_id"),
            @Result(property = "time",column = "p_time"),
            @Result(property = "style",column = "p_style"),
            @Result(property = "content",column = "p_content"),
            @Result(property = "level",column = "p_level"),
    })
    @Select("select * from t_plan where p_level = #{qwer}")
    List<Plan> getByLevel(String level);
}
